CREATE VIEW [dbo].[vSoaInvoiceLine]
AS

SELECT InvoiceLineId,
       InvoiceId,
       LineNumber,
       ItemId,
       ShipToPartyId,
       Quantity,
       UnitPrice,
       ExtendedAmount,
       PaymentAdjustmentAmount,
       PendingPaymentAdjustmentAmount,
       Balance,
       BILL_DATE
FROM vSoaInvoiceLineAR       

UNION ALL

SELECT InvoiceLineId,
       InvoiceId,
       LineNumber,
       ItemId,
       ShipToPartyId,
       Quantity,
       UnitPrice,
       ExtendedAmount,
       PaymentAdjustmentAmount,
       PendingPaymentAdjustmentAmount,
       Balance,
       BILL_DATE
FROM vSoaInvoiceLineCash


GO